Working with Oracle, using TEMPORARY tablespaces with tempfiles is best practice today. Unfortunately there are two situations in which you may encounter trouble as for the tempfiles are missing and sort operations do no longer succeed. Curiously and based on the fact that Oracle does not record checkpoint information in tempfiles, Oracle can even start … Continue reading Recover from Missing Tempfiles